Client Maintenance / Client Parameters / Collateral Reserves
Collateral Reserves
The collateral reserve calculations is usually calculated under additional BBC calculations, this amount will be deducted from the individual collaterals or from the total BBC availability of the borrower.
This screen allows you to set up additional collateral types with the associated advance rate, value, and reserve limit.
Navigation: Client Maintenance → Client Parameters → Collateral Reserves
Refer to the screenshot:
Fields and Descriptions
Fields |
Descriptions |
Collateral |
Specifies the collateral name. |
Description |
Defines the reserve type. |
Advance % |
Specifies the reserve amount in percentage %. |
Value |
Specify the value for the reserve. |
Reserves |
Specifies the total reserve amount. |
Based On |
Allows the user to select any one of the following to calculate the collateral reserves based on the selected option: Gross Net Eligible Available Borrowing Base Total Available for Advance Total Collateral Credit Line |
Calculated By |
Allows the user to select the collateral name to calculate the collateral reserve. |
Reserve % |
Specifies the total percentage of reserve amount. |
To setup a new collateral reserve, perform these steps:
1. Click the button to create a new record.
2. In Collateral field, select the collateral name from the drop-down list
3. Enter the description of the Reserve.
4. Enter the Advance %.
5. Enter the Value of the Reserve.
6. In Based On column, select any one of the option from the drop-down list.
If user selects Based On option as Credit Line or Total Available for Advance or Total Collateral, then the system displays the Calculated By option in disable mode.
7. In Calculated By column, select any one of the option from the drop-down list.
8. In Reserve % column, enter Collateral Reserve % value.
9. Click the button. The new collateral reserve is setup in the application. You can also add multiple collateral reserves. You can edit, delete, and export the details as required.
You can add the either reserve limit (%) or advance rate (%). If both the values are added for a particular collateral type, an error popup appears.
Refer to the screenshot:
Total AR Reserves = Total AR Available for Advance x %declare on collateral Reserves screen.
Total Inventory Reserve = Total Inventory Available for Advance x %declare on collateral Reserves screen.
Total Other Collateral Reserve = Total AR Available for Advance x %declare on collateral Reserves screen.
Total Reserves = Total Collateral value x %declare on collateral Reserves screen.
To search the collateral reserve, perform these steps:
1. From the Collateral Type drop-down, choose a collateral type.
2. Click the button to search the record. A Search page appears.
Refer to the screenshot:
3. Populate all the fields as required.
4. Click the button to search the collateral reserve based on the selected options. (Or)
5. Click the button to reset the fields that you have selected.
To export the collateral reserve data, perform these steps:
1. Click the button to export the collateral reserve data.
Refer to the screenshot:
2. Click button to export the collateral reserve date in an excel format. A pop-up message “Do you want to open or save collateral_reserve.xls from cyncsoftware.com?” appears.
3. Click Open if you want to open the extracted collateral reserve data or click Save. The collateral reserve data is extracted in an excel format.
Refer to the screenshot: